#
# This file is a part of the open-eBackup project.
# This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
# If a copy of the MPL was not distributed with this file, You can obtain one at
# http://mozilla.org/MPL/2.0/.
#
# Copyright (c) [2024] Huawei Technologies Co.,Ltd.
#
# THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
# EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
# MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
#

from sqlalchemy import String, Column, BigInteger, Text, text
from sqlalchemy.ext.declarative import declarative_base

BaseModel = declarative_base()


class SqlServerIndex(BaseModel):
    __tablename__ = 'T_COPY_METADATA'

    UUID = Column(String(64), primary_key=True)
    NAME = Column(Text)
    TYPE = Column(String(32))
    PARENT_PATH = Column(Text)
    PARENT_UUID = Column(String(64))
    SIZE = Column(BigInteger)
    CREATE_TIME = Column(String(64), server_default=text("(datetime('now', 'localtime'))"))
    MODIFY_TIME = Column(String(64), server_default=text("(datetime('now', 'localtime'))"))
    EXTEND_INFO = Column(Text)
    RES_TYPE = Column(String(64))
    RES_SUB_TYPE = Column(String(64))